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 10 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

Food Chains and Food Webs Quiz
Selam H
Spanish Adjectives (Describing People)
Niat Habtemariam
A Level: English language and literature techniques = Structure
Jessica 'JessieB
Chemical Symbols
Keera
Statistics Key Words
Culan O'Meara
Religious Studies- Matters of life and death
Emma Samieh-Tucker
An Inspector calls - Gerald Croft
Rattan Bhorjee
GCSE Biology B1 (OCR)
Usman Rauf
Test your Knowledge with Quizzes
daniel.praecox
Chemistry GCSE Review - States of Matter, Particles, Atoms, Elements, Compounds and Mixtures
Morgan Overton
General Pathoanatomy Final MCQs (401-519)- 3rd Year- PMU
Med Student