Font size
WorksheetsOperations Team Swiggy
Total questions: 85
Worksheet time: 1hrs 1mins
Excel file is saved as a ____________
Document
workbook
worksheets
Presentation
Workbook is made up of -----------------------
(a)
What is a sheet in Excel?
A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.
A single document that typically contains labels, values, formulas, functions, and graphical representations of data.
A single file that typically contains labels, values, formulas, functions, and graphical representations of data.
Each spreadsheet is made up of ____________ and ______________
(a)
Name of the workbook is displayed in the ___________
Menu bar
Title bar or ribbon
Tool bar
option bar
The name box or the address bar contains
Formulas
menu options
Cell address
Numbers
Formula applied to a cell appears in the (a)
Letters in Excel represent
rows
data
columns
functions
Numbers in the worksheet represent
data
columns
rows
functions
Define Cell?
The dark bordered box in excel.
A box in Excel that has formulas.
The intersection of a column or row in a worksheet or table.
Fx Bar where you input data
1. What is the "Active Cell" in Excel?
The Bottom cell in a worksheet. It is indicated by a dark border onscreen
The current cell in a worksheet. It is indicated by a dark border onscreen.
The top cell in a worksheet. It is indicated by a dark border onscreen
The past cell in a worksheet. It is indicated by a dark border onscreen
When starting a formula what is the first thing you type in the cell?
&
=
%
+
What is the Sum formula?
Sum( )
Sum( )=
=( )Sum
=Sum( )
To quickly add a set of number you can use the ____ feature?
Plus Sum Button
Add Sum Button
Quick Add Button
Auto Sum Button
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
For multiplying numbers in A1 AND B1,you use the following formula
=A1/B1
=A1*B1
A1%B1
A1*B1
Address of the current cell is contained in
Name box
Cell address
Status bar
Formula bar
The option that reduces the font size of the data to accommodate it within the column width
Shrink to fit
Columns
Text orientation
Wrap text
When inserting a formula, always start with
Plus symbol
Equal symbol
Minus symbol
Division symbol
The option which accommodates the text in a column by using multiple lines
Text orientation
Wrap text
Merge cells
None of these
To apply formatting on cells, select the option "Cells" from _________ menu
Edit
Format
Home
Allignment
A program using a table comprising of rows, columns and cells
MS Word
MS PowerPoint
MS Outlook
MS Excel
Excel allows you to
Read stories
Invent ideas
Work with data
Helps in coding
What do you call the blank boxes on the spreadsheet?
Name box
Squares
Cells
Spots
Numbers in excel is automatically aligned to the
Left
Right
Centre
Justified
Cells that run horizontally on a spreadsheet are know as
Row
Column
Workbook
Range
Vertical arrangement of cells is known as
Range
Cell
Row
Column
Area within the red box is called
Active cell
Fill handle
Cell
Row
Name of the workbook is displayed in the
Menu bar
Title bar
Tool bar
Option bar
The name box contains
Formula
Menu option
Cell address
Numbers
Numbers in the worksheet represent
Data
Columns
Rows
Functions
Define cell
The dark bordered box in excel
A box in excel that has formula
The intersection of a column and a row in a worksheet
None of the above
What is the active cell in excel
The bottom cell in a worksheet
The top cell in a worksheet
The Past cell in a worksheet
The current cell in a worksheet
Name the cell address selected in the picture
C3
B2
B:3
B3
This symbol is used to
Minimize
Maximize
Exit/Close
Save
Which key should be used to move to the left of the cell
Tab key
Enter key
Shift+ Enter key
Shift+ Tab key
The address for s single file on the internet is called it's:
HTTP
ISP
HTML
URL
A) Name
B) Address
C) Phone Number
D) None of the above
A) Keeping passwords a secret & being nice
B) Telling an adult when I fell unsafe
C) None of the above
D) All of the above
What is connecting a computer to the Internet called? Choose the BEST answer.
going online
surfing the web
browsing the web
downloading
What is the World Web usually called for short?
surfing
web
browsing
Internet
Business operations is the department in a business that is responsible for:
Marketing
Finance
Production of goods/provision of services
Human resources
Which of the following products is likely to be made using job production?
Heinz baked beans
Cadburys Dairy Milk
Land Rover car
Made to measure wedding dress
Which of the following is a feature of flow production?
Products are produced continually on a production line
Products are one-off meeting customer needs exactly
Products are made in small identical groups
Cost of producing one unit is high
A benefit to a business of introducing lean production methods is that:
Unit costs should be minimised in the long term
New processes will be easily implemented
Training costs will be low
All staff will be happy to take on additional responsibilities
Which of the following stock control methods would involve frequent deliveries?
Flow production
Just in case
Job production
Just in time
A business that becomes more streamlined as a result of effective supply chain management is said to be running more:
Bureaucratically
Expensively
Efficiently
Autocratically
Which of the following is a benefit to a business of minimising waste in its supply chain?
Lower unit costs
Higher labour turnover
Higher revenue
Purchasing economies of scale can be achieved
Which of the following is a direct benefit of having an efficient logistics department?
Products arrive exactly when needed
Labour productivity will reduce
Efficiency will be minimised
Staff motivation will increase
Total quality management aims to:
Give production line staff minimal say in the level of quality standards
Check quality standards at the end of the production line
Ensure that quality is the responsibility of everyone in an organisation
Ensure a single person/single team is responsible for quality
An advantage to a business of asking customers to complete on line surveys regarding customer services is that:
An unbalanced view of quality standards may be gained
Low response rate
Cost effective to set up
Incentive to complete the surveys may need to be offered
The process of meeting customer needs successfully before, during and after a sale is called:
Procurement
Kaizen
Customer service
The sales process
An employee greeting a customer and offering help when required are specific examples of:
The sales process
Post sales service
Customer engagement
Product knowledge
Which of the following is a danger to a business of offering poor customer service?
Increased flexibility with pricing
Increased revenue
Negative word of mouth
Satisfied customers
A business that allows its customers to make purchases in store, via its website or by the telephone is called a(n):
Pure play retailer
Omni-channel retailer
E-tailer
Bricks and mortar retailer
The process of coordinating people and resources to ensure everything is in the right place at the right time is the role of which department in a business?
Logistics
Procurement
Supply chain management
Purchasing
Which of the following is an advantage of job production relative to other production methods?
Unit costs will be lower
Production speeds are faster
Workers may be better motivated
Fewer resources are needed
Dental treatment is provided using which form of production?
Flow production
Batch production
Job production
Capital-intensive production
A manufacturer employs 18 machinists in a workshop. During a single week, 1440 pairs of jeans are produced. Therefore, labour productivity per worker for the week was how many pairs of jeans
80 pairs
25 920 pairs
1440 pairs
18 pairs
Which of the the following products is likely to be made using batch production?
Mobile phones
Toilet paper
Petrol
Clothes
Which of the following is an advantage of just-in-time production?
Labour productivity is increased
Stock holding costs are significantly reduced
Lead times are lengthened
Dependence on the reliability of suppliers increases
Lean production focuses on which of the following?
Increasing labour productivity
Improving cash flow
Using fewer resources
Making production more capital intensive
What does kaizen mean?
Land of the rising sun
Continuous improvement
Multi-skilling
Market orientated
Which of the following is a practice associated with kaizen?
Extension strategies
Skimming
Product differentiation
Empowerment
Which of the following is a feature of TQM?
Quality chains
Product differentiation
Cash flow forecasting
Labour intensive production methods
Which of the following is a potential disadvantage of TQM
Waste and inefficiences rise
It is expensive to implement
It is not recognised globally
It is unclear
Employing a specialist cost accountant in a growing business is an example of which type of economy?
Technical economy
Risk-bearing economy
Managerial economic
Marketing economy
What impact will internal economies of scale have on costs?
Total costs will fall
Average costs will rise
Variable costs will rise
Average costs will fall
Which of the following is an example of an external economy of scale?
Increased cooperation and information sharing between businesses
Rising costs of inputs
Lower costs owing to bulk buying
Better efficiency resulting from the specialisation of labour
Which of the following is a possible time limit to business growth?
Fall in the exchange rate
Government restrictions
Marketing constraints
Lack of finance
