Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
test corrections
| Question | Answer |
|---|---|
| Trey would like to outline the cell range A1:F20. Which formatting style should he select | boarders |
| Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select? | conditional formatting |
| Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1? | today |
| Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should he use | count if |
| Which command do you use to reduce the margin between the border and the text in an indented cell? | decrease indent |
| Which command on the Home Ribbon do you use to organize data in ascending or descending order | sort an filter |
| Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select? | orientation |
| Jessica needs to capitalize the first letter in each word. Which function would she use? | proper |
| What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls? | freeze panels |
| Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion? | sort and filter |
| Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose | ascending |
| Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy | breaks |
| What is the process of bringing data containing text fields separated by commas into Excel called? | importing data |
| What is a prewritten formula that is built into Microsoft Excel called | function |
| Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel | font |
| In Sam's spreadsheet, Column A has student first and last names. They need to be separated into two different columns. Which tool would he use | convert text and column wizard |
| On the Home Ribbon, what do you use to change the text color of characters in a cell? | font color drop down list |
| Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to show a summary view of all of the first period classes. Which feature would allow him to do this? | collapose |
| Where can you find the Insert Function button in Microsoft Excel | formula bar |
| In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand? | formatting |
Created by:
1574638