Excel 1

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

The undo button will allow you to reverse up to ___ previous actions one at a time

100

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

Answer, 5

You can use the ___ keys s damn the keyboard to navigate a worksheet

Arrow

The excel operator for exponent is ____

Carrot (^)

The Excel operator for division is ____.

Coward slash (/)

You can change or ___ the contents of an active cell at any time

Edit

In a worksheet, the ___ is called the formula prefix

Equal sign

The___ option helps fit data in a single page

Escape to fit

A(n) ___is a built in formula that uses arguments to calculate information

Function

A(An) ___ is an entry in a cell that contains text such as 2016 sales or Travel Expenses

Label

The ____ sheet button allows you to add worksheet to a workbook

New

You can use ____ to move around around in a document that is to large to fit on screen

Scroll bars

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

Sheet tabs

You can edit the contents of the active cell by ____.

Typing

In a payroll worksheet, Peter worked 40 hours and actual date stored in B5. This is called a ___

Value

You can use the __ slider on the status bar to enlarge the views

Zoom

To quickly jump to the last cell in a worksheet press ____.

[Ctrl][End]

To quickly jump to the first cell in a worksheet press ____.

[Ctrl][Home]

____ operators perform mathematical calculations such as adding and subtracting.

arithmetic

All Excel formulas begin with the ____.

equal sign (=)

The entry in cell B15 is =SUM(B5:B14) which is a ____.

formula

While you are entering a formula in a cell, the cell references and arithmetic operators appear in the ____

formula bar

The name Peter is entered in cell B4. This is a ____.

label

Possible paper orientations for printing a worksheet are landscape and ____.

portrait

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

spreadsheet

You can use predesigned, formatted files called ____ to create new worksheets quickly.

templates

To display gridlines on a worksheet, click the Gridlines check box in the __________ group on the View tab.

to show

In Excel, a worksheet is contained in a file called a ____.

workbook

In excel, the electronic spreadsheet you work in is called a _____

worksheet


Kaugnay na mga set ng pag-aaral

Chapter 3: Communication & Culture

View Set

Business Environment and Trade: The International Landscape

View Set

Principles of Public Speaking practice exam 2

View Set