MS excel set 13 Detailed Explanation And More Example

Question : 1

In Excel Tab scrolling button

a) Allow you to view a different worksheet

b) Allow you to view additional worksheet rows down

c) Allow you to view additional worksheet columns to the right

d) Allow you to view additional sheets tabs

Question : 2

You can use the formula palette to

a) format cells containing numbers

b) create and edit formula containing functions

c) enter assumptions data

d) copy a range of cells

e) None of these

Question : 3

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

a) Shorten the label

b) Increase the column width

c) Decrease the column width

d) Adjust the row height

e) None of these

Question : 4

In Excel to balance your checkbook, your best method is

a) Copy your check amounts into Excel so that you’ll have a neat printout to work on

b) Use Excel to check your arithmetic

c) Download the Checkbook register templates from Templates on Microsoft Office Online

d) All of above

Question : 5

You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which Command should you use?

a) New

b) Save As

c) Edit

d) Save

e) None of these

Question : 6

How do you insert a row?

a) Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

b) Select the row heading where you want to insert the new row and select Edit > Row from the menu

c) Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

d) All of the above

e) None of these