Excel 2010 - Chapter 1

Description

Flashcards on Excel 2010 - Chapter 1, created by dee.walker217 on 17/08/2014.
dee.walker217
Flashcards by dee.walker217, updated more than 1 year ago
dee.walker217
Created by dee.walker217 over 9 years ago
20
0

Resource summary

Question Answer
Open Excel by clicking on this button at the left side of the Task bar. START BUTTON
A file created in Excel is referred to as a: WORKBOOK
A workbook consists of these WORKSHEETS
Contains buttons for commonly used commands. QUICK ACCESS toolbar
Click this tab and the Backstage view displays containing buttons and tabs for working with and managing files FILE TAB
Displays workbook name followed by program name TITLE BAR
Contain commands and features organized into groups TITLE BAR
Area containing the tabs and commands divided into groups RIBBON
Displays cell address (also called the cell reference) and includes the column letter & row number NAME BOX
Provides information about active cell; enter and edit formulas in the bar. FORMULA BAR
Displays toward bottom of screen and identifies current workdsheet SHEET TAB
Displays information about worksheet and active cell, view buttons, and Zoom slider bar. STATUS BAR
Area containing gridlines WORKSHEET
Columns are labelled with these: LETTERS
Rows are labelled with these: NUMBERS
Scroll through a worksheet using these: HORIZONTAL and/or VERTICAL SCROLL BARS
Data you type appears in two spots: THE CELL & FORMULA BAR
If a number is too long to fit in a cell, Excel changes the display of the number to this: NUMBER SYMBOLS (####)
A workbook file name can contain up to this amount of characters 255
This button automatically inserts a formula containing the SUM function, which adds the numbers in a range. AUTOSUM
This function is a common function in Excel formulas. AVERAGE function
This function sums the numbers in a range of cells and then divides the sum by the number of cell entries AVERAGE function
These do not display unless they are typed in a cell DECIMALS and COMMAS
This is a general guideline in accounting regarding entering dollar amounts in a spreadsheet Dollar sign before first number amount in a column and before the total amount in a column, but not before the number amounts in between.
Show full summary Hide full summary

Similar

The Heart
annalieharrison
PHYSICS P1 1
x_clairey_x
The First, Second, Third and Fourth Crusades
adam.melling
Plant and animal cells
charlotteireland
Chemistry Module C1: Air Quality
James McConnell
Sociology- Key Concepts
Becky Walker
Cell Transport
Elena Cade
Health and Social Care
Kelsey Phillips
Meteorologia I
Adriana Forero
2PR101 1.test - Doplňující otázky
Nikola Truong
1PR101 2.test - Část 14.
Nikola Truong