When can cells and ranges be formatted in a worksheet ?
What is Before or after data is entered
100
What formatting is automatically updated if you change data in the worksheet?
What is Conditional
100
What toolbar is fully customizable?
What is Quick Access
100
Once you have created a table, the _________ appears on the Ribbon
What is table tools, design tab and tables tool layout
200
In the formula =ROUND (D4:F4,0) what does the zero indicate?
What is The number of decimal places
200
Which element of the Word program window displays information about the current document such as number of pages, and also includes the view and zoom buttons?
What is Status bar
200
What is an interactive object that you to customize a document with your own information?
What is Content control
200
What is the keyboard shortcut for pasting text?
What is [Ctrl V]
200
Which feature allows you to copy multiple format settings at once in Word?
What is Format painter
300
Which command on the Table menu would you use to insert a pre-formatted table template?
What is Quick Tables
300
Click the formula button in the _________ group on the Table Tools Layout tab to open the Formula dialog box.
What is Data
300
What do the minimal allowable margins settings depend on?
What is Printer
300
What happens to the data in the copied cells when cells are copied using Excel's copy function?
What is The data remains in it's original location
300
Where is the Zoom slider located?
What is On the Status Bar
400
A Smart Art graphic consists of two parts: the Smart graphic itself and a (n) _______pane
What is Text
400
What can you use to move around in a document that is too large to fit on the screen at once?
What is Scroll bars
400
How do you jump quickly to the first cell in a worksheet?
What is Press Ctrl Home
400
Excel templates make creating a professional looking spreadsheet easier by including all of the ______
What is Data
400
What key allows the Excel user to cycle through all possible combinations of relative mixed and absolute cell references for a formula?
What is F4
500
The ______ is the physical size of the text.
What is Font
500
What is the maximum number of slides you can have on a handout?
What is Nine
500
The slide tab displays each slide as a(n) _________
What is Thumbnail
500
Pressing shift as you drag to create a shape maintains the shape's _________ as you change size.
What is Proportions
500
You can set different slide timings for each _______