What are the five elements of all Information Systems

People, Process, Data, Software, Hardware

Which of these is NOT an Excel feature?

Communication: email, voice, text

Which of these is not an Excel activity?

Systems - Databases, ERP's, CRM

All of these are Excel best practices except:

Use actual values eg 'Yes' or 'No' in formulas, avoid unnecessary reference

Which of these is NOT true about Excel?

Excel is Hard to Use – Complex & difficult to learn - years to proficiency

All of these are benefits of OneDrive except:

Your files are protected against phishing

Which of these in NOT a data source for Excel?

Analyze and compute - formulas, functions, and pivot tables.

All of these are true or attributes of Excel except:

Standalone: Does not integrate with other applications

studbud

IS2000 - Excel / Microsoft Overview

15 termsStudBud Administration225 plays

Imported from external platform

Flashcards15 cardsFPractice quizPHost liveL

Questions 15

Answers

1
Presentation software with slideshows and lectures.
Teams
Powerpoint
Publisher
Access
2
Collaboration and communication platform with Video conferencing, team messaging, and file sharing.
Teams
Publisher
OneDrive
Access
3
What are the five elements of all Information Systems
Management, Workflow, Data, Software, Networks
People, Workflow, Information, Software, Networks
Management, Process, Information, Software, Hardware
People, Process, Data, Software, Hardware
4
Which of these is NOT an Excel feature?
Basic arithmetic: SUM, AVERAGE, etc
Logical functions: IF, AND, OR
Communication: email, voice, text
Statistical functions: STDEV, COUNT, MIN, MAX
5
Which of these is not an Excel activity?
Input Validate - Rules, error clean-up, validations
Visualize and Present - build charts, graphs, and dashboards.
Systems - Databases, ERP's, CRM
Analyze and Compute - Formulas, functions, and pivot tables.
6
All of these are Excel best practices except:
Use actual values eg 'Yes' or 'No' in formulas, avoid unnecessary reference
Use consistent font styles, sizes, and colors for headers, data, and labels
Use comments, or sheet to explain formulas, assumptions, or instructions.
Test to ensure functions as intended.
7
Which of these is NOT true about Excel?
Excel Improves Your Productivity – improve the speed of getting job done
Excel for All Types of Audiences – use for personal, business, & other uses
Excel is Hard to Use – Complex & difficult to learn - years to proficiency
Excel Generates Competitive Advantage, differentiates you in the job market
8
All of these are benefits of OneDrive except:
You can restore your files to a previous version
Your files save automatically
Your files are protected against phishing
Your files are backed up in the cloud
9
Which of these is NOT an example of a spreadsheet:
Visicalc
Excel
Word
Mesopotomanian Clay Tablets
10
Which of these in NOT a data source for Excel?
Files - CSV, Excel, and text
Systems - Databases, ERP's & CRM
Analyze and compute - formulas, functions, and pivot tables.
Web - API's, web scraping, online forms
11
If you want to store your files in the cloud, and retrieve them later from any device, you should use what?
Teams
Excel
OneDrive
OneNote
12
Note taking software for notes, brainstorming and journaling:
Word
Teams
OneDrive
OneNote
13
Excel usage is limited primarily to Accounting and Project Management usage.
True
False
14
The very best, most complete version of Excel software to use, and the preferred version for our class is:
Excel 365 for Windows
Excel 2019
Excel 365 for Mac
Excel Online
15
All of these are true or attributes of Excel except:
Standalone: Does not integrate with other applications
Spreadsheet application: developed by Microsoft
Grid Structure: Organized into a grid rows and columns
Storage: Stores Data in files

IS2000 - Excel / Microsoft Overview Flashcards | StudBud