ShortCuts
Which of the following keyboard shortcuts will help you replace data?
What is Ctrl+H
Most formatting options are available for use from which tab on the ribbon?
What is home
Which rule applies to a naming a table?
What is Cannot start with a number, Cannot be the same name as a default cell reference name, Cannot contain spaces
Using the Paste Values option allows you to change a workbook in what way?
What is replace functions with the actual data
How many tabs are there in the Page Setup dialog box?
What is 4
Where on screen will you find the Formula bar?
What is underneath the ribbon.
The Theme Fonts group on the Font list includes fonts for which of the following types of text in cells?
What is body and headings
Which of the following options are ways you can name a cell range?
What is Create from Selection, Name Box, Name Manager
Which of the following file formats can you use to import data in text format into an Excel workbook?
What is .csv and .txt
Where can you go to add the current date to the Footer?
What is File > Print > Page Setup > Header/Footer tab > Custom Footer or Scale to Fit dialog launcher on the ribbon > Header/Footer tab
The word Jan was entered in cell A1, Apr was entered in cell B1, and you then used AutoFill to automatically fill cells C1 and D1. What would cell D1 contain?
What is October
To remove all custom formatting from one or more cells, select the cell(s), and then use the _________________ command.
What is clear formats
A _____ is a command that applies a unique combination of borders and shading that you can use to change the appearance of a table.
What is Style
You use the _________ function to convert text such as a state abbreviation to capital letters.
What is UPPER
Which of the following methods can you use to change the paper size?
What is File > Print > Page Setup > Page tab or File > Print > choose the option under Settings or Select Size on the Page Layout tab
In which of the following tabs will you find the Insert Function command?
What is Formulas
When you have text in a cell that is too long for the cell width, possible formatting solutions include:
What is wrap text and rotate text up
The _____ ___ displays totals for each column of a table.
What is Total Row
In the Function Library, which of the following categories will you find the MAX and MIN functions?
What is Statistical
To check for accessibility issues, you can go to File > Info, and then _____ ______ ______.
What is check for issues
You access the Find command via the _________ group on the Home tab.
What is editing
To reuse formatting from one or more cells and apply that same formatting to one or more selections of other cells, you would use __________________.
What is format painter
Which of the following commands will clear all filters in a worksheet?
Data tab, Sort & Filter group, Clear
What is the answer to the following calculation: 5+2*(20-10)/2?
What is 15
Why you should remove personal information and hidden properties from a workbook.
What is personal information can be found by anyone with access to your data.