MCQs | eBooks – Textbook Solutions All types eBook are available

MS Excel

Web Technology (91)
- Ecommerce (26)
- Amazon (32)
Data Warehousing MCQ (4)
Data Mining (63)
- Cryptocurrency (28)
Computer Networks (26)
Computer Graphics (32)
Data Structures (20)
Database (9)
Operating System (1)
Windows Programming (4)
HTML5 (22)
HTML (34)
MS Excel (49)
Artificial Intelligence (AI) (99)
Search engine optimization (SEO) (45)
Python (31)

The name box

A. Appears to the left of the formula bar B. Shows the location of the previously active cell C. Appears below the menu bar D. Appears below the status bar AnswerOption: A

When a label is too long to fit within a worksheet cell, you typically must

A. Adjust the row height B. Decrease the column width C. Shorten the label D. Increase the column width AnswerOption: D

When you want to insert a blank imbedded excel object in a word document you can

A. Click the import excel command on the file menu B. Click the office links button on the standard toolbar C. Click the create worksheet button on the formatting toolbar D. Click the object command on the insert menu AnswerOption: D

Excel uniquely identifies cells within a worksheet with a cell name

A. Column letters and row numbers B. Column numbers and row letters C. Cell names D. Cell locator coordinates AnswerOption: A

The auto calculate feature

A. Automatically creates formulas and adds them to a worksheet B. Can only add values in a range of cells C. Provides a quick way to view the result of an arithmetic operation on a range of cells D. A and C AnswerOption: C

Data can be arranged in a worksheet in a easy to understand manner using

A. changing fonts B. applying styles C. auto formatting D. all of above AnswerOption: D

A numeric value can be treated as a label value if it precedes with

A. Ampersand (&Wink B. Apostrophe C. Hash (#) D. Exclamation (!) AnswerOption: B

Tab scrolling button

A. Allow you to view additional sheets tabs B. Allow you to view a different worksheet C. Allow you to view additional worksheet columns to the right D. Allow you to view additional worksheet rows down AnswerOption: A