Excel - Unit A - Review

Ace your homework & exams now with Quizwiz!

Which view shows you a reduced view of each page of your worksheet?

page break preview

Which worksheet view shows how your worksheet will look when printed?

page layout

In which view can you see the header and footer areas of a worksheet?

page layout view

Selection of multiple cells.

range

Which feature could be used to print a very long worksheet on a single sheet of paper?

scale to fit

In which area can you see a preview of your worksheet?

backstage view

Using a cell address in a formula is known as:

cell referencing

In an Excel worksheet - how many boxes do you find in your header view?

3

A1 = 5 B2 = 10 B1 = 2 What is answer to this formula =(B2*2) + (A1*B1)

30

A1 = 5 B2 = 10 C3 = 3 What is answer to this formula =(A1*B2) - (C3 x 3)

41

A1 = 5 B2 = 10 What is answer to this formula =(A1*B2)-2

48

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?

5

A1 = 5 B2 = 10 C3 = 3 What is answer to this formula =(A1*B2) + (C3 x 3)

59

A1 = 5 B2 = 10 What is answer to this formula =(A1*2)-2

8

Columns are identified in Excel by using __________________________.

Alphabetical letters

Equal sign preceding a formula

Formula prefix

A1 = 5 B2 = 10 If the following is shown on the formula bar for cell A3 - what would be shown on the worksheet? (A1*2)-2

(A1*2)-2

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained A1/A2, what would cell A3 show on the worksheet?

A1/A2

Name box

Displays the active cell address.

Which key can you press to switch to Edit mode?

F2

Cell

Intersection of a row and a column.

Formula Bar

Location in Excel where you find the formulas for cells.

Default view in Excel

Normal view

Rows are identified in Excel by using ____________________.

Numbers

Direction in which contents of page will print

Orientation

Maximum number of worksheets you can include in a workbook is _____________________.

Unlimited

File consisting of one or more worksheets

Workbook

An excel workbook is made up of

Worksheets


Related study sets

EXAM 2 Chapter 51: Assessment and Management of Patients with Diabetes Prep-U, EXAM 2 Adult Prep U CH 51 Assessment and Management of Patients With Diabetes part 2

View Set

Module 1 section a: Supply chain management concepts

View Set

Encounters With Life Exercise 22- Kingdom Animalia

View Set

Introduction to International Relations

View Set

Chapter 24 Assessment of the Respiratory System

View Set

TCU Nutrition Gorman Ch 8&9 Study Guide

View Set