Basics of Excel - Flashcard 1

Front

What is the keyboard shortcut to open a new workbook?

Back

Ctrl + N

Front

Which tab in MS Excel allows you to change font styles, colors, and alignment of text? Options: Insert, Home, Page Layout, Data

Back

Home

Front

What is the shortcut key to go to the next cell while entering data in Excel?

Back

Tab

Front

Where can you find the option to freeze panes in Excel? Options: Page Layout tab, Insert tab, View Tab, Home tab

Back

View Tab

Front

What is the maximum number of rows available in an Excel worksheet (Excel 2016 and later)?

Back

1,048,576

Front

Which tab contains the "Format as Table" option?

Back

Home

Front

What happens if you try to enter text that exceeds the width of a column?

Back

The text is cut off and displays as hashtags (#####).

Front

How can you quickly fill a series of numbers or dates in adjacent cells?

Back

Dragging the fill handle

Front

Which feature allows you to sort data in ascending or descending order?

Back

Sort & Filter in the Data tab

Front

What is the purpose of the "Format Painter" tool?

Back

To copy formatting from one cell to another