Operating System

Tuesday, March 17, 2015

Excel 2010 Test Questions 29

Leave a Comment
146. Which function do you use to insert today’s date in a worksheet so that it automatically updates each time the worksheet is opened?

A.    Today
B.     Weekday
C.     Date
D.    CurrentDate

Answer: A

147. Which command do you use to remove manual page breaks from a worksheet area?

A.    Select break, press Delete on keyboard
B.     Select Remove Page Break from the Breaks drop-down area
C.     Select break, press Backspace on keyboard
D.    Select break, press Remove Page Break from Shortcut Menu

Answer: B

148. What is the name of the technique of entering a number once and copying it so that it is entered in the same cell on all selected worksheets?

A.    Pushing
B.     Forcing through
C.     Drilling an entry
D.    Entry Demand

Answer: C

149. What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?

A.    Calling the Sheet
B.     Name reference
C.     Sheet Name
D.    Sheet Reference

Answer: D

150. What is a range that spans two or more sheets in a workbook?

A.    Wide range
B.     3-D range
C.     Workbook range
D.    Sheet range


Answer: B
If You Enjoyed This, Take 5 Seconds To Share It

0 comments:

Post a Comment