Mastering Excel Basics: Data Entry and Formatting

What do you click to access the Page Layout Ribbon?

• Home Tab

• Page Layout Tab

• Launch Button

• Insert Tab

What is the purpose of the launch button in Excel 2016?

• To open a new Excel sheet

• To access additional options within a group

• To close the Excel application

• To save the current workbook

How is a cell named in Excel?

• By the Excel system automatically

• By its content

• By the user manually

• By its row and column headers

What defines a range in Excel?

• The entire spreadsheet

• A group of adjacent cells

• A group of non-adjacent cells

• A single cell

What is a workbook in Excel?

• A template for financial modeling

• A single worksheet

• A collection of charts

• A collection of worksheets

How do you enter data into a cell?

• Press Enter and then type

• Click the cell once and type

• Double-click the cell and type

• Right-click the cell and select 'Enter Data'

What does pressing 'Shift + Enter' do in Excel?

• Saves the current workbook

• Opens a new Excel workbook

• Moves the selection to the cell above

• Deletes the current cell's content

How do you navigate to the right within a spreadsheet without using the mouse?

• Press Enter

• Press Shift + Tab

• Press Tab

• Press the right arrow key

What is the difference between being 'on' a cell and being 'in' a cell?

• There is no difference

• 'On' a cell shows the formula, 'in' a cell shows the result

• 'On' a cell allows editing, 'in' a cell allows selecting

• 'On' a cell allows you to select it, 'in' a cell allows you to edit its content

How can you make the text in a cell bold?

• Use the 'Bold' button in the Home tab

• Press 'Ctrl + B'

• Right-click the cell and choose 'Bold'

• Double-click the cell and type '**' before and after the text